File manager - Edit - /home/autoph/public_html/projects/Rating-AutoHub/public/css/sales.zip
Back
PK ''�ZNM sales_about_side.phpnu �[��� <!-- Profile Image --> <div id="customer-about-me" class="card card-primary card-outline col-12" style="display: ;"> <div class="input-forms card-body box-profile"> <div class="text-center"> <h5 class="text-center">Order Number: <span id="sales-order-number"></span></h5> </div> <div class="text-center"> <h5 class="text-center">PO Number: <span id="sales-po-number"></span></h5> </div> <div class="text-center"> Sales Date: <span id="sales-date" style="font-size: 14px;" ></span> </div> <div class="text-center"> Sales Cost: <span id="sales-sales-cost" style="font-size: 14px;" ></span> </div> <div class="text-center mb-3"> Sales Price: <span id="sales-sale-price" style="font-size: 14px;" ></span> </div> <ul class="list-group list-group-unbordered mb-3"> <li class="list-group-item"> <div class="form-group row my-0"> <span class="col-sm-5 lbl-forms-sm"><strong>Brand</strong> <span class="float-right">:</span></span> <span class="col-sm-7 lbl-forms-sm" id="sales-brand"></span> </div> </li> <li class="list-group-item"> <div class="form-group row my-0"> <span class="col-sm-5 lbl-forms-sm"><strong>Model</strong> <span class="float-right">:</span></span> <span class="col-sm-7 lbl-forms-sm" id="sales-model"></span> </div> </li> <li class="list-group-item"> <div class="form-group row my-0"> <span class="col-sm-5 lbl-forms-sm"><strong>Plate Number</strong> <span class="float-right">:</span></span> <span class="col-sm-7 lbl-forms-sm" id="sales-plate-number"></span> </div> </li> <li class="list-group-item"> <div class="form-group row my-0"> <span class="col-sm-5 lbl-forms-sm"><strong>Conduction Sticker</strong> <span class="float-right">:</span></span> <span class="col-sm-7 lbl-forms-sm" id="sales-cs-number"></span> </div> </li> <li class="list-group-item"> <div class="form-group row my-0"> <span class="col-sm-5 lbl-forms-sm"><strong>Serial Number</strong> <span class="float-right">:</span></span> <span class="col-sm-7 lbl-forms-sm" id="sales-serial-number"></span> </div> </li> <li class="list-group-item"> <div class="form-group row my-0"> <span class="col-sm-5 lbl-forms-sm"><strong>Engine Number</strong> <span class="float-right">:</span></span> <span class="col-sm-7 lbl-forms-sm" id="sales-engine-number"></span> </div> </li> <li class="list-group-item"> <div class="form-group row my-0"> <span class="col-sm-5 lbl-forms-sm"><strong>Customer</strong> <span class="float-right">:</span></span> <span class="col-sm-7 lbl-forms-sm" id="sales-owner-name"></span> </div> </li> <li class="list-group-item"> <div class="form-group row my-0"> <span class="col-sm-5 lbl-forms-sm"><strong>Type</strong><span class="float-right">:</span></span> <span class="col-sm-7 lbl-forms-sm" id="sales-owner-type"></span> </div> </li> <li class="list-group-item"> <div class="form-group row my-0"> <span class="col-sm-5 lbl-forms-sm"><strong>Email</strong><span class="float-right">:</span></span> <span class="col-sm-7 lbl-forms-sm" id="sales-owner-email"></span> </div> </li> <li class="list-group-item"> <div class="form-group row my-0"> <span class="col-sm-5 lbl-forms-sm"><strong>Mobile</strong><span class="float-right">:</span></span> <span class="col-sm-7 lbl-forms-sm" id="sales-owner-mobile"></span> </div> </li> <li class="list-group-item"> <div class="form-group row my-0"> <span class="col-sm-5 lbl-forms-sm"><strong>Sales Person</strong><span class="float-right">:</span></span> <span class="col-sm-7 lbl-forms-sm" id="sales-sales-person"></span> </div> </li> </ul> </div><!--card-body--> </div><!--card card-primary--> PK ''�Z��d�q �q modal/add_sales.phpnu �[��� <!-- Modal --> <div class="modal fade" id="modal-sales" tabindex="-1" data-backdrop="static" aria-labelledby="exampleModalCenterTitle" aria-hidden="true"> <div class="modal-dialog modal-dialog-scrollable modal-xl" role="document"> <div class="modal-content"> <div class="modal-header" style="background: #077BFF;"> <h5 class="modal-title" id="exampleModalCenterTitle"><span id="modal-title" style="color: white;"></span></h5> <button id="close-modal-button"type="button" class="close" data-dismiss="modal" aria-label="Close"> <span aria-hidden="true" style="color: white;">×</span> </button> </div> <div class="modal-body"> <!-- <div class="bs-stepper"> --> <!-- <div class="bs-stepper-header" role="tablist"> --> <!-- your steps here --> <!-- <div class="step" data-target="#information-part"> <button type="button" class="step-trigger" role="tab" aria-controls="information-part" id="information-part-trigger"> <span class="bs-stepper-circle">1</span> <span class="bs-stepper-label">Information</span> </button> --> <!-- </div> <div class="line"> </div> <div class="step" data-target="#contact-part"> <button type="button" class="step-trigger" role="tab" aria-controls="contact-part" id="contact-part-trigger"> <span class="bs-stepper-circle">2</span> <span class="bs-stepper-label">Contact</span> </button> </div> --> <!-- <div class="line"> </div> --> <!-- <div class="step" data-target="#children-part"> <button type="button" class="step-trigger" role="tab" aria-controls="children-part" id="children-part-trigger"> <span class="bs-stepper-circle">3</span> <span class="bs-stepper-label">Children</span> </button> </div> --> <!-- </div> --> <!-- <div class="bs-stepper-content"> --> <!-- <div id="information-part" class="content" role="tabpanel" aria-labelledby="information-part-trigger"> --> <fieldset class="card"> <legend>Vehicle Information</legend> <div class="row"> <div id="div-sales-cs-number" class="col-sm-6"> <div class="form-group mx-0 my-0"> <label class="lbl-forms mx-0 my-0">Conduction Sticker</label> <input id="mod-sales-cs-number" type="text" class="edit-customer lbl-forms-sm form-control form-control-sm" style="background-color: transparent;"> </div> </div> <div id="div-sales-plate-number" class="col-sm-6"> <div class="form-group mx-0 my-0"> <label class="lbl-forms mx-0 my-0">Plate Number</label> <input id="mod-sales-plate-number" type="text" class="edit-customer lbl-forms-sm form-control form-control-sm" style="background-color: transparent;"> </div> </div> </div> <div class="row"> <div id="div-sales-vehicle-brand" class="col-sm-4"> <div class="form-group mx-0 my-0"> <label class="lbl-forms mx-0 my-0">Brand</label> <input id="mod-sales-vehicle-brand" type="text" class="edit-customer lbl-forms-sm form-control form-control-sm" style="background-color: transparent;"> </div> </div> <div id="div-sales-vehicle-model" class="col-sm-4"> <div class="form-group mx-0 my-0"> <label class="lbl-forms mx-0 my-0">Model</label> <input id="mod-sales-vehicle-model" type="text" class="edit-customer lbl-forms-sm form-control form-control-sm" style="background-color: transparent;"> </div> </div> <div id="div-sales-vehicle-color" class="col-sm-4"> <div class="form-group mx-0 my-0"> <label class="lbl-forms mx-0 my-0">Color</label> <input id="mod-sales-vehicle-color" type="text" class="edit-customer lbl-forms-sm form-control form-control-sm" style="background-color: transparent;"> </div> </div> </div> </fieldset> <fieldset class="card"> <legend>SALES</legend> <div class="row"> <div id="div-order-number" class="col-sm-6"> <div class="form-group mx-0 my-0"> <label class="lbl-forms mx-0 my-0">Order Number</label> <input id="mod-order-number" type="text" class="edit-customer lbl-forms-sm form-control form-control-sm" style="background-color: transparent;"> </div> </div> <div id="div-po-number" class="col-sm-6"> <div class="form-group mx-0 my-0"> <label class="lbl-forms mx-0 my-0">PO Number</label> <input id="mod-po-number" type="text" class="edit-customer lbl-forms-sm form-control form-control-sm" style="background-color: transparent;"> </div> </div> </div> <hr> <div class="row"> <div id="div-modal-sales-dates" class="col-sm-4"> <div class="form-group mx-0 my-0"> <label class="lbl-forms mb-0">Sales Date</label> <div class="edit-customer input-group date" id="div-sales-date" data-target-input="nearest"> <input name="mod-sales-date" id="mod-sales-date" data-inputmask-alias="datetime" data-inputmask-inputformat="mm/dd/yyyy" data-mask type="text" class="edit-customer lbl-forms-sm form-control form-control-sm datetimepicker-input" data-target="#mod-sales-date" /> <div class="edit-customer input-group-append" data-target="#mod-sales-date" data-toggle="datetimepicker"> <div class="input-group-text"><i class="fa fa-calendar"></i> </div> </div> </div> </div> </div> <div id="div-modal-sales-cost" class="col-sm-4"> <div class="form-group mx-0 my-0"> <label class="lbl-forms mb-0">Sales Cost</label> <div class="input-group mb-2"> <div class="input-group-append"> <div class="input-group-text edit-customer lbl-forms-sm form-control form-control-sm"> <span class="">₱</span> </div> </div> <input onkeyup="if (/\D/g.test(this.value)) this.value = this.value.replace(/\D/g,'')" type="text" name="mod-sales-cost" id="mod-sales-cost" class="edit-customer lbl-forms-sm form-control form-control-sm"> </div> </div> </div> <div id="div-modal-sales-price" class="col-sm-4"> <div class="form-group mx-0 my-0"> <label class="lbl-forms mb-0">Sales Price</label> <div class="input-group mb-2"> <div class="input-group-append"> <div class="input-group-text edit-customer lbl-forms-sm form-control form-control-sm"> <span class="">₱</span> </div> </div> <input onkeyup="if (/\D/g.test(this.value)) this.value = this.value.replace(/\D/g,'')" type="text" name="mod-sales-price" id="mod-sales-price" class="edit-customer lbl-forms-sm form-control form-control-sm"> </div> </div> </div> </div> </fieldset> <div class="row"> <div class="col-sm-12"> <fieldset class="card"> <legend>SALES AMT & DATES</legend> <div class="row mx-0 my-0"> <div class="col-sm-6"> <div id="div-modal-floor-plan-amount" class="form-group dropdown-input mx-0 my-0"> <div class="form-group mx-0 my-0"> <label class="lbl-forms mb-0">Floor Plan Amount</label> <div class="input-group mb-2"> <div class="input-group-append"> <div class="input-group-text edit-customer lbl-forms-sm form-control form-control-sm"> <span class="">₱</span> </div> </div> <input onkeyup="if (/\D/g.test(this.value)) this.value = this.value.replace(/\D/g,'')" type="text" name="mod-floor-plan-amount" id="mod-floor-plan-amount" class="edit-customer lbl-forms-sm form-control form-control-sm"> </div> </div> </div> </div> <div class="col-sm-6"> <div id="div-claim-amount" class="form-group dropdown-input mx-0 my-0"> <div class="form-group mx-0 my-0"> <label class="lbl-forms mb-0">Claim Amount</label> <div class="input-group mb-2"> <div class="input-group-append"> <div class="input-group-text edit-customer lbl-forms-sm form-control form-control-sm"> <span class="">₱</span> </div> </div> <input onkeyup="if (/\D/g.test(this.value)) this.value = this.value.replace(/\D/g,'')" type="text" name="mod-claim-amount" id="mod-claim-amount" class="edit-customer lbl-forms-sm form-control form-control-sm"> </div> </div> </div> </div> </div> <div class="row mx-0 my-0"> <div class="col-sm-6"> <div id="div-claim-number" class="form-group dropdown-input mx-0 my-0"> <div class="form-group mx-0 my-0"> <label class="lbl-forms mb-0">Claim Number</label> <input id="mod-claim-number" type="text" class="edit-customer lbl-forms-sm form-control form-control-sm" style="background-color: transparent;"> </div> </div> </div> <div class="col-sm-6"> <div id="div-deal-number" class="form-group dropdown-input mx-0 my-0"> <div class="form-group mx-0 my-0"> <label class="lbl-forms mb-0">Deal Number</label> <input id="mod-deal-number" type="text" class="edit-customer lbl-forms-sm form-control form-control-sm" style="background-color: transparent;"> </div> </div> </div> </div> <div class="row mx-0 my-0"> <div class="col-sm-6"> <div id="div-deal-date" class="form-group dropdown-input mx-0 my-0"> <div class="form-group mx-0 my-0"> <label class="lbl-forms mb-0">Deal Date</label> <div class="edit-customer input-group date" id="div-deal-date" data-target-input="nearest"> <input name="mod-deal-date" id="mod-deal-date" data-inputmask-alias="datetime" data-inputmask-inputformat="mm/dd/yyyy" data-mask type="text" class="edit-customer lbl-forms-sm form-control form-control-sm datetimepicker-input" data-target="#mod-deal-date" /> <div class="edit-customer input-group-append" data-target="#mod-deal-date" data-toggle="datetimepicker"> <div class="input-group-text"><i class="fa fa-calendar"></i> </div> </div> </div> </div> </div> </div> <div class="col-sm-6"> <div id="div-delivery-date" class="form-group dropdown-input"> <div class="form-group mx-0 my-0"> <label class="lbl-forms mb-0">Delivery Date</label> <div class="edit-customer input-group date" id="div-delivery-date" data-target-input="nearest"> <input name="mod-delivery-date" id="mod-delivery-date" data-inputmask-alias="datetime" data-inputmask-inputformat="mm/dd/yyyy" data-mask type="text" class="edit-customer lbl-forms-sm form-control form-control-sm datetimepicker-input" data-target="#mod-delivery-date" /> <div class="edit-customer input-group-append" data-target="#mod-delivery-date" data-toggle="datetimepicker"> <div class="input-group-text"><i class="fa fa-calendar"></i> </div> </div> </div> </div> </div> </div> </div> <div class="row mx-0 my-0"> <div class="col-sm-6"> <div id="div-warehouse" class="form-group dropdown-input mx-0 my-0"> <div class="form-group mx-0 my-0"> <label class="lbl-forms mb-0">Warehouse</label> <input id="mod-warehouse" type="text" class="edit-customer lbl-forms-sm form-control form-control-sm" style="background-color: transparent;"> </div> </div> </div> <div class="col-sm-6"> <div id="div-stock-number" class="form-group dropdown-input mx-0 my-0"> <div class="form-group mx-0 my-0"> <label class="lbl-forms mb-0">Stock Number</label> <input id="mod-stock-number" type="text" class="edit-customer lbl-forms-sm form-control form-control-sm" style="background-color: transparent;"> </div> </div> </div> </div> <div class="row mx-0 my-0"> <div class="col-sm-6"> <div id="div-age-of-unit" class="form-group dropdown-input mx-0 my-0"> <div class="form-group mx-0 my-0"> <label class="lbl-forms mb-0">Age of Unit</label> <input id="mod-age-of-unit" type="text" class="edit-customer lbl-forms-sm form-control form-control-sm" style="background-color: transparent;"> </div> </div> </div> <div class="col-sm-6"> <div id="div-body-size-code" class="form-group dropdown-input mx-0 my-0"> <div class="form-group mx-0 my-0"> <label class="lbl-forms mb-0">Body Size Code</label> <input id="mod-body-size-code" type="text" class="edit-customer lbl-forms-sm form-control form-control-sm" style="background-color: transparent;"> </div> </div> </div> </div> <div class="row mx-0 my-0"> <div class="col-sm-6"> <div id="div-insurance-company" class="form-group dropdown-input mx-0 my-0"> <div class="form-group mx-0 my-0"> <label class="lbl-forms mb-0">Insurance Company</label> <select name="mod-insurance-company" id="mod-insurance-company" class="edit-customer lbl-forms-sm form-control form-control-sm" style="width: 100%;"> <option></option> <?php $ins_type = $db -> return_result("SELECT `id`, `name` FROM `source_insurance_company` WHERE status != 0 ORDER BY id ASC"); foreach($ins_type as $data){ echo "<option value='{$data['id']}'>".$data['name']."</option>"; } ?> </select> </div> </div> </div> <div class="col-sm-6"> <div id="div-insurance-type" class="form-group dropdown-input mx-0 my-0"> <div class="form-group mx-0 my-0"> <label class="lbl-forms mb-0">Insurance Type</label> <select name="mod-insurance-type" id="mod-insurance-type" class="edit-customer lbl-forms-sm form-control form-control-sm" style="width: 100%;"> <option></option> <?php $ins_type = $db -> return_result("SELECT `id`, `name` FROM `source_insurance_type` WHERE status != 0 ORDER BY id ASC"); foreach($ins_type as $data){ echo "<option value='{$data['id']}'>".$data['name']."</option>"; } ?> </select> </div> </div> </div> </div> <div class="row mx-0 my-0"> <div class="col-sm-6"> <div id="div-insurance-exp-date" class="form-group dropdown-input mx-0 my-0"> <div class="form-group mx-0 my-0"> <label class="lbl-forms mb-0">Insurance Expiration Date</label> <div class="edit-customer input-group date" id="div-insurance-exp-date" data-target-input="nearest"> <input name="mod-insurance-exp-date" id="mod-insurance-exp-date" data-inputmask-alias="datetime" data-inputmask-inputformat="mm/dd/yyyy" data-mask type="text" class="edit-customer lbl-forms-sm form-control form-control-sm datetimepicker-input" data-target="#mod-insurance-exp-date" /> <div class="edit-customer input-group-append" data-target="#mod-insurance-exp-date" data-toggle="datetimepicker"> <div class="input-group-text"><i class="fa fa-calendar"></i> </div> </div> </div> </div> </div> </div> <div class="col-sm-6"> <div id="div-financing-company" class="mb-0 form-group"> <label class="lbl-forms mx-0 my-0">Financing Company</label> <select name="mod-financing-company" id="mod-financing-company" class="edit-customer lbl-forms-sm form-control form-control-sm" style="width: 100%;"> <option></option> <?php $finance = $db -> return_result("SELECT `id`, `name` FROM `source_finance_company` WHERE status != 0 ORDER BY id ASC"); foreach($finance as $data){ echo "<option value='{$data['id']}'>".$data['name']."</option>"; } ?> </select> </div> </div> </div> <div class="row mx-0 my-0"> <div class="col-sm-6"> <div id="div-finance-exp-date" class="form-group dropdown-input mx-0 my-0"> <div class="form-group mx-0 my-0"> <label class="lbl-forms mb-0">Finance Expiration Date</label> <div class="edit-customer input-group date" id="div-finance-exp-date" data-target-input="nearest"> <input name="mod-finance-exp-date" id="mod-finance-exp-date" data-inputmask-alias="datetime" data-inputmask-inputformat="mm/dd/yyyy" data-mask type="text" class="edit-customer lbl-forms-sm form-control form-control-sm datetimepicker-input" data-target="#mod-finance-exp-date" /> <div class="edit-customer input-group-append" data-target="#mod-finance-exp-date" data-toggle="datetimepicker"> <div class="input-group-text"><i class="fa fa-calendar"></i> </div> </div> </div> </div> </div> </div> </div> <div class="row mx-0 my-0"> <div class="col-sm-6"> <div id="div-sales-consultant" class="form-group dropdown-input mx-0 my-0"> <div class="form-group mx-0 my-0"> <label class="lbl-forms mb-0">Sales Consultant</label> <input id="mod-sales-consultant" type="text" class="edit-customer lbl-forms-sm form-control form-control-sm" style="background-color: transparent;"> </div> </div> </div> <div class="col-sm-6"> <div id="div-group-manager" class="form-group dropdown-input mx-0 my-0"> <div class="form-group mx-0 my-0"> <label class="lbl-forms mb-0">Group Manager</label> <input id="mod-group-manager" type="text" class="edit-customer lbl-forms-sm form-control form-control-sm" style="background-color: transparent;"> </div> </div> </div> </div> </fieldset> </div> </div> <div class="row"> <div class="col-sm-12"> <fieldset class="card"> <legend>DATA SOURCE</legend> <div class="row"> <div class="col-sm-4"> <div class="form-group"> <label class="lbl-forms mx-0 my-0">DMS</label> <select id="mod-dd-dms" class="edit-customer lbl-forms-sm form-control form-control-sm" style="width: 100%; height: 28px;"> <?php $dms = $db -> return_result("SELECT `id`,`name` FROM `source_dms` WHERE status != '0' ORDER by name ASC"); foreach($dms as $data){ echo "<option value='{$data['id']}'>".$data['name']."</option>"; } ?> </select> </div> </div> <div class="col-sm-4"> <div class="form-group"> <label class="lbl-forms mx-0 my-0">Company</label> <select id="mod-dd-company" class="edit-customer lbl-forms-sm form-control form-control-sm" style="width: 100%;"> <?php $company = $db -> return_result("SELECT `id`,`name`, `code` FROM `source_company` WHERE status != '0' ORDER by code ASC"); foreach($company as $data){ echo "<option value='{$data['id']}'>".$data['code'] . " - " . $data['name']."</option>"; } ?> </select> </div> </div> <div class="col-sm-4"> <div class="form-group"> <label class="lbl-forms mx-0 my-0">Dealer</label> <select id="mod-dd-dealer" class="edit-customer lbl-forms-sm form-control form-control-sm" style="width: 100%;"> <?php $dealer = $db -> return_result("SELECT `id`,`name`, `code` FROM `source_dealer` WHERE status != '0' ORDER by code ASC LIMIT 10"); foreach($dealer as $data){ echo "<option value='{$data['id']}'>".$data['code'] . " - " . $data['name']."</option>"; } ?> </select> </div> </div> <div class="col-sm-3" hidden> <div class="form-group dropdown-input"> <label class="lbl-forms mx-0 my-0" >Date Created:</label> <div class="edit-customer input-group date" id="ind-date-created" data-target-input="nearest"> <input name="mod-date-created" id="ind-date-created" data-inputmask-alias="datetime" data-inputmask-inputformat="mm/dd/yyyy" data-mask type="text" class="edit-customer lbl-forms-sm form-control form-control-sm datetimepicker-input" data-target="#ind-date-created" /> <div class="edit-customer input-group-append" data-target="#ind-date-created" data-toggle="datetimepicker"> <div class="input-group-text"><i class="fa fa-calendar"></i> </div> </div> </div> </div> </div> </div> </fieldset> </div> </div> <!-- </div> --> <!-- </div> --> <!-- </div> --> <div class="overlay" id="ind-edit-loader" style="display: none;"> <div class="fas fa-2x fa-sync-alt fa-spin "> </div> <strong><span class="ml-2" id="loading-message"> Loading, please wait...</span></strong> </div> </div><!--modal body--> <div class="modal-footer"> <button id="close-button" type="button" class="btn btn-secondary btn-sm" data-dismiss="modal">Close</button> <button id="proceed-button" type="button" class="btn btn-success btn-sm"><span></span></button> </div> </div> </div> </div>PK ''�ZS�C,n n sales_information.phpnu �[��� <div id="individual-customer" class="card card-primary card-outline col-12" style="display: ;"> <div class="card-body"> <div class="tab-content"> <form id="form-individual" class="form-horizontal"> <div class="row"> <div class="col-sm-6 mb-3"> <span class="span-labels"><strong>Date created:  </strong> </span> <span class="span-values" id="sales-date-created"></span> </div> <!-- <div class="col-6 mb-3 text-right"> <input type="button" id="edit-sales" class="btn btn-primary btn-sm mr-1" value="Edit" title="Edit Sales Info" data-toggle="modal" data-target="#modal-sales"></input> <input type="button" id="remove-sales" onclick="" class="btn btn-danger btn-sm" value="Remove" title="Remove/Hide Sale Record"></input> </div> --> </div> <div class="form-group row mb-2"> <span class="col-sm-4 lbl-forms-sm"><strong>Customer Discount</strong></span> <input type="text" class="col-sm-8 lbl-forms-sm form-control form-control-sm" id="sales-sale-discount" readonly style="background-color: transparent;"></input> </div> <div class="form-group row mb-2"> <span class="col-sm-4 lbl-forms-sm"><strong>Floor Plan Amount</strong></span> <input type="text" class="col-sm-8 lbl-forms-sm form-control form-control-sm" id="sales-floor-plan-amount" readonly style="background-color: transparent;"></input> </div> <div class="form-group row mb-2"> <span class="col-sm-4 lbl-forms-sm"><strong>Claim Number</strong></span> <input type="text" class="col-sm-8 lbl-forms-sm form-control form-control-sm" id="sales-claim-number" readonly style="background-color: transparent;"></input> </div> <div class="form-group row mb-2"> <span class="col-sm-4 lbl-forms-sm"><strong>Claim Amount</strong></span> <input type="text" class="col-sm-8 lbl-forms-sm form-control form-control-sm" id="sales-claim-amount" readonly style="background-color: transparent;"></input> </div> <div class="form-group row mb-2"> <span class="col-sm-4 lbl-forms-sm"><strong>Deal Number</strong></span> <input type="text" class="col-sm-8 lbl-forms-sm form-control form-control-sm" id="sales-deal-number" readonly style="background-color: transparent;"></input> </div> <div class="form-group row mb-2"> <span class="col-sm-4 lbl-forms-sm"><strong>Deal Date</strong></span> <input type="text" class="col-sm-8 lbl-forms-sm form-control form-control-sm" id="sales-deal-date" readonly style="background-color: transparent;"></input> </div> <div class="form-group row mb-2"> <span class="col-sm-4 lbl-forms-sm"><strong>Delivery Date</strong></span> <input type="text" class="col-sm-8 lbl-forms-sm form-control form-control-sm" id="sales-delivery-date" readonly style="background-color: transparent;"></input> </div> <div class="form-group row mb-2"> <span class="col-sm-4 lbl-forms-sm"><strong>Warehouse</strong></span> <input type="text" class="col-sm-8 lbl-forms-sm form-control form-control-sm" id="sales-warehouse" readonly style="background-color: transparent;"></input> </div> <div class="form-group row mb-2"> <span class="col-sm-4 lbl-forms-sm"><strong>Stock Number</strong></span> <input type="text" class="col-sm-8 lbl-forms-sm form-control form-control-sm" id="sales-stock-number" readonly style="background-color: transparent;"></input> </div> <div class="form-group row mb-2"> <span class="col-sm-4 lbl-forms-sm"><strong>Age of Unit</strong></span> <input type="text" class="col-sm-8 lbl-forms-sm form-control form-control-sm" id="sales-age-of-unit" readonly style="background-color: transparent;"></input> </div> <div class="form-group row mb-2"> <span class="col-sm-4 lbl-forms-sm"><strong>Body Size Code</strong></span> <input type="text" class="col-sm-8 lbl-forms-sm form-control form-control-sm" id="sales-body-size-code" readonly style="background-color: transparent;"></input> </div> <div class="form-group row mb-2"> <span class="col-sm-4 lbl-forms-sm"><strong>Insurance Company</strong></span> <input type="text" class="col-sm-8 lbl-forms-sm form-control form-control-sm" id="sales-insurance-company" readonly style="background-color: transparent;"></input> </div> <div class="form-group row mb-2"> <span class="col-sm-4 lbl-forms-sm"><strong>Insurance Type</strong></span> <input type="text" class="col-sm-8 lbl-forms-sm form-control form-control-sm" id="sales-insurance-type" readonly style="background-color: transparent;"></input> </div> <div class="form-group row mb-2"> <span class="col-sm-4 lbl-forms-sm"><strong>Insurance Expiration Date</strong></span> <input type="text" class="col-sm-8 lbl-forms-sm form-control form-control-sm" id="sales-insurance-expiration-date" readonly style="background-color: transparent;"></input> </div> <div class="mt-3 mb-0 row"> <div class="col-sm-4"> <div class="form-group"> <span class="span-labels"><strong>Date Uploaded:  </strong></span><br> <span id="sales-date-uploaded" class="span-values"></span> </div> </div> <div class="col-sm-4"> <span class="span-labels"><strong>Uploaded By:  </strong> </span><br> <span id="sales-uploaded-by" class="span-values"></span> </div> <div class="col-sm-4"> <span class="span-labels"><strong>DMS:  </strong> </span> <span id="sales-dms" class="span-values"></span><br> <span class="span-labels"><strong>Company:  </strong> </span> <span id="sales-company" class="span-values"></span><br> <span class="span-labels"><strong>Dealer:  </strong> </span> <span id="sales-dealer" class="span-values"></span> </div> </div> </form> <!-- /.tab-pane --> </div> <!-- /.tab-content --> </div><!-- /.card-body --> </div> PK �;�Z�9!F� � sales.phpnu �[��� <?php include_once("../../cfg/db.php"); if ($_SERVER["REQUEST_METHOD"] != "POST") { $return_arr["message"]=" You are not allowed to do this action."; echo $return_arr["message"]; return; } if(isset($_REQUEST['apiKey']) ){ $apiKey = $_REQUEST['apiKey']; if($apiKey === '43245237842'){ if(isset($_REQUEST['customer_id'])){ $customer_record_id = $db -> escape(trim($_REQUEST['customer_id'])); echo json_encode(getFilteredSalesData($customer_record_id,'ASC','2',$db)); }else{ $return_arr["message"]=" You are not allowed to do this action."; echo $return_arr["message"]; return; } }else{ $return_arr["message"]=" You are not allowed to do this action."; echo $return_arr["message"]; return; } }else{ $return_arr["message"]=" You are not allowed to do this action."; echo $return_arr["message"]; return; } function getFilteredSalesData($customer_record_id,$order_by,$sort_by,$db){ $customer_id = " AND v.customer_record_id = $customer_record_id "; switch(intval($sort_by)){ case 1: //lastname $filter_sort_by = " c.last_name "; break; case 2: //firstname $filter_sort_by = " c.first_name "; break; case 3: //corporation name $filter_sort_by = " c.corporation_name "; break; case 4: //date created $filter_sort_by = " s.activity_date "; break; case 5: //date uploaded $filter_sort_by = " s.date_uploaded "; break; } $return_data['sales'] = array(); $query = "SELECT %s FROM sales s INNER JOIN vehicle v ON s.vehicle_id = v.id LEFT OUTER JOIN service se ON se.vehicle_id = v.id INNER JOIN source_brand sb ON v.brand_id=sb.id INNER JOIN source_car_model scm ON v.model_id=scm.id INNER JOIN source_company_dealer scd ON scd.id=s.company_dealer_id INNER JOIN source_company sc ON sc.id = scd.company_id INNER JOIN source_dealer sd ON sd.id= scd.dealer_id INNER JOIN employee e ON s.upload_by = e.id INNER JOIN source_dms sdms ON sc.dms_id = sdms.id LEFT OUTER JOIN customer c ON v.customer_record_id = c.id LEFT OUTER JOIN customer_contact cc ON c.id = cc.customer_id LEFT OUTER JOIN customer_category ccat ON c.category_id = ccat.id LEFT OUTER JOIN sales_consultant sct ON s.sales_person = sct.id WHERE 1 %s /* custromer ids */ AND v.status = 1 AND s.status = 1 GROUP BY v.id ORDER BY $filter_sort_by $order_by"; $count = " count(1) "; $fields = " v.brand_id,v.model_id, sb.name as brand, scm.name as model,s.id, s.order_number, s.po_number, s.activity_date, s.customer_id,s.sales_cost,s.sale_price,s.sale_discount,s.claim_amount,s.floor_plan_amount,v.conduction_sticker,v.plate_number,s.serial_number,s.engine_number,s.claim_number,s.deal_number,s.deal_date,s.stock_number, s.warehouse,s.age_of_unit,sdms.name as dms_name,sc.code as company_name,sd.code as dealer_name, s.date_uploaded,concat(e.first_name,' ',e.last_name) as upload_by,CONCAT(sct.first_name, ' ', sct.last_name) as sales_person, IF( c.type = 1, concat(c.first_name,' ',c.middle_name,' ',c.last_name),c.corporation_name ) as name "; echo (sprintf($query, $fields,$customer_id)); exit; $data_list = $db -> sql_query(sprintf($query, $fields,$customer_id)); $query_count = $db -> select("SELECT COUNT(*) FROM ( ".sprintf($query, $count,$customer_id)." ) as total_count"); if( $query_count > 0){ $record_counter = 1; foreach ($data_list as $data){ $return_data['sales'] = array_merge($return_data['sales'],array(array( // 'No.'=>$record_counter++, 'record_id'=>$data['id'], 'customer_id'=>$data['customer_id'], 'brand'=> $data['brand'], 'model'=> $data['model'], 'plate_number'=>$data['plate_number'], 'conduction_sticker'=>$data['conduction_sticker'], 'order_number'=>$data['order_number'], 'po_number'=>$data['po_number'], 'sales_cost'=>($data['sales_cost'] <> '' ) ? number_format($data['sales_cost'],2) : "", 'sale_price'=>($data['sale_price'] <> '' ) ? number_format($data['sale_price'],2) : "", 'sale_discount'=>($data['sale_discount'] <> '' ) ? number_format($data['sale_discount'],2) : "", 'claim_amount'=>$data['claim_amount'], 'floor_plan_amount'=>$data['floor_plan_amount'], 'serial_number'=>$data['serial_number'], 'engine_number'=>$data['engine_number'], 'claim_number'=>$data['claim_number'], 'deal_number'=>$data['deal_number'], 'deal_date'=>$data['deal_date'], 'stock_number'=>$data['stock_number'], 'warehouse'=>$data['warehouse'], 'age_of_unit'=>$data['age_of_unit'], 'sales_person'=>$data['sales_person'], 'dms'=>$data['dms_name'], 'company'=>$data['company_name'], 'dealer'=>$data['dealer_name'], 'sales_date'=>$data['activity_date'], 'date_uploaded'=>$data['date_uploaded'], 'upload_by'=>$data['upload_by'], ))); } $return_data['found'] = $query_count." Record".((intval($query_count) < 2) ? '' : 's' )." Found"; }else{ $return_data['found'] = "No Record Found"; // $return_data = array_merge($return_data,array(array('Order Number'=>'','PO Number'=>'','Date'=>'','Sales Person'=>'','Customer Name'=>''))); } $return_data['total'] = $query_count; return array($return_data); } function isNotEmpty($data){ return preg_match('/\S/', $data); } function quote($str) { return sprintf("'%s'", $str); } ?>PK �;�Z 4�6� � error_lognu �[��� [24-Jun-2025 08:59:28 Asia/Manila] PHP Warning: mysqli::query(): (HY000/3): Error writing file '/tmp/MYrCdqWA' (Errcode: 28 - No space left on device) in /home/autoph/public_html/connectv1/cfg/func.php on line 30 [25-Jun-2025 15:08:11 Asia/Manila] PHP Warning: mysqli::query(): (HY000/3): Error writing file '/tmp/MYXNgLvZ' (Errcode: 28 - No space left on device) in /home/autoph/public_html/connectv1/cfg/func.php on line 30 PK �;�ZU��tn tn salesv2.phpnu �[��� <?php include_once("../../cfg/db.php"); include_once("../controllers/sales.php"); include_once("../controllers/utility.php"); include_once("../controllers/brand.php"); include_once("../controllers/model.php"); include_once("../controllers/color.php"); include_once("../controllers/vehicle.php"); include_once("../controllers/insurance.php"); include_once("../controllers/insurance_type.php"); include_once("../controllers/finance.php"); include_once("../controllers/group_manager.php"); include_once("../controllers/sales_consultant.php"); include_once("../controllers/sales.php"); include_once("../compliance/required_fields.php"); $sales = new Sales(); $utility = new Utility(); $brand = new Brand(); $model = new Model(); $color = new Color(); $vehicle = new vehicle(); $insurance_company = new Insurance(); $insurance_type = new InsuranceType(); $finance_company = new Finance(); $group_manager = new GroupManager(); $sales_consultant = new SalesConsultant(); $required_fields = new RequiredFields(); $sales = new Sales(); if(!isset($_SESSION['user']['id'])){ echo "Session Expired."; exit; } $server_method = $_SERVER["REQUEST_METHOD"]; $granted_company_ids = $utility->isNotEmpty($_SESSION['user']['company_permissions_implode']) ? $_SESSION['user']['company_permissions_implode'] : '-1' ; if(isset($_REQUEST['apiKey']) ){ $apiKey = $_REQUEST['apiKey']; if($apiKey === '1289076901116235' && $utility->isPostMethod($server_method)){ //Create $vehicle_id = isset($_REQUEST['vehicle_id']) ? $db->escape($_REQUEST['vehicle_id']) : '-1'; $sale_id = $utility->generate_uuid($db); $vehicle_data = isset($_REQUEST['sales_data']) ? $_REQUEST['sales_data'] : '{}'; $vehicle_data_array = json_decode($vehicle_data, true); $vehicle_data_array = array_map(array($utility, 'upperCaseNestedArray'), $vehicle_data_array); $vehicle_data_array = array_map(array($db, 'escape'), $vehicle_data_array); $insurance_company_name = ($vehicle_data_array["mod-dd-insurance-company"]); if($utility->isNotEmpty($insurance_company_name)){ $insurance_company_id = $insurance_company->read_insurance_company_id_by_name($insurance_company_name, $db); if(!$utility->isNotEmpty($insurance_company_id)){ $insurance_company_id = $insurance_company->create_insurance_company($insurance_company_name, $db); } } else { $insurance_company_id = 0; } // echo $insurance_company_id;exit; $finance_company_name = ($vehicle_data_array["mod-dd-finance-company"]); if($utility->isNotEmpty($finance_company_name)){ $finance_company_id = $finance_company->read_finance_company_id_by_name($finance_company_name, $db); if(!$utility->isNotEmpty($finance_company_id)){ $finance_company_id = $finance_company->create_finance_company($finance_company_name, $db); } } else { $finance_company_id = 0; } //DATE FORMATS $insurance_expiration_date = ""; if($utility->isNotEmpty($vehicle_data_array["mod-insurance-exp-date"])){ $insurance_expiration_date = $utility->convert_sql_date($vehicle_data_array["mod-insurance-exp-date"],'mm/dd/yyyy'); } $finance_expiration_date = ""; if($utility->isNotEmpty($vehicle_data_array["mod-finance-exp-date"])){ $finance_expiration_date = $utility->convert_sql_date($vehicle_data_array["mod-finance-exp-date"],'mm/dd/yyyy'); } $delivery_date = ""; if($utility->isNotEmpty($vehicle_data_array["mod-delivery-date"])){ $delivery_date = $utility->convert_sql_date($vehicle_data_array["mod-delivery-date"],'mm/dd/yyyy'); } $sales_date = ""; if($utility->isNotEmpty($vehicle_data_array["mod-sales-date"])){ $sales_date = $utility->convert_sql_date($vehicle_data_array["mod-sales-date"],'mm/dd/yyyy'); } $insert_vehicle_sales = $sales->create_vehicle_sales( $sale_id, '',//$customer_dms_id, $vehicle_id, '',//$vehicle_data_array['mod-cs-number'], '',//$vehicle_data_array['mod-plate-number'], $vehicle_data_array['mod-order-number'], '',//$floor_plan_amount, $sales_date, $vehicle_data_array['mod-sales-cost'], $vehicle_data_array['mod-sales-price'], $vehicle_data_array['mod-sales-discount'], $insurance_company_id, $vehicle_data_array['mod-dd-insurance-type'], $insurance_expiration_date, $finance_company_id, $finance_expiration_date, $vehicle_data_array['mod-dd-source-of-sale'], '0',//$mode_of_contact_id, '',//$warehouse, '',//$stock_number, '',//$age_of_unit, '',//$body_size_code, '',//$claim_number, '',//$claim_amount, '',//$deal_number, '',//$deal_date, $vehicle_data_array['mod-dd-sales-consultant'], $vehicle_data_array['mod-driver'], $delivery_date, $vehicle_data_array['mod-dd-type-of-payment'], $vehicle_data_array['mod-dd-group-manager'], '0',//$company_dealer_id, '',//$purchase_car_as_id, $_SESSION['user']['id'], '1',//$status $vehicle_data_array['mod-end-user'], $vehicle_data_array['mod-dd-mode-of-sale'], $db); $vehicle_brands_offered = isset($_REQUEST['vehicle_brands_offered']) ? $_REQUEST['vehicle_brands_offered'] : '' ; $vehicle_brands_offered_array = array(); if($vehicle_brands_offered <> ''){ $vehicle_brands_offered = array_map(array($utility, 'upperCaseNestedArray'), $vehicle_brands_offered); $vehicle_brands_offered = array_map(array($db, 'escape'), $vehicle_brands_offered); foreach ($vehicle_brands_offered as $offered){ $description = ($offered['Description']); $brands_offered_id = ($offered['Brand']); $model_offered_id = ($offered['Model']); // $model_offered_name = ($offered['Model']); // $model_offered_id = $model->read_model_id_by_name($model_offered_name, $db); $vehicle_brands_offered_array[] = "('$sale_id','" . $brands_offered_id."', '".$model_offered_id."', '".$description."')"; } $vehicle_brands_offered_to_insert = implode(',', $vehicle_brands_offered_array); $sales->create_sales_brands_offered($vehicle_brands_offered_to_insert, $db); } if($insert_vehicle_sales > 0){ $return_arr["status"] = 1; $return_arr["message"] = "Successfully inserted"; }else { $return_arr["status"] = 0; $return_arr["message"] = "Record not inserted"; } echo json_encode($return_arr); }else if($apiKey === '1767826750337195' && $utility->isPostMethod($server_method)){ //Update $vehicle_id = isset($_REQUEST['vehicle_id']) ? $db->escape($_REQUEST['vehicle_id']) : '-1'; $sale_id = $sales->get_sales_id_by_vehicle_id($vehicle_id,$db); $vehicle_data = isset($_REQUEST['sales_data']) ? $_REQUEST['sales_data'] : '{}'; $vehicle_data_array = json_decode($vehicle_data, true); $vehicle_data_array = array_map(array($utility, 'upperCaseNestedArray'), $vehicle_data_array); $vehicle_data_array = array_map(array($db, 'escape'), $vehicle_data_array); $insurance_company_name = ($vehicle_data_array["mod-dd-insurance-company"]); if($utility->isNotEmpty($insurance_company_name)){ $insurance_company_id = $insurance_company->read_insurance_company_id_by_name($insurance_company_name, $db); if(!$utility->isNotEmpty($insurance_company_id)){ $insurance_company_id = $insurance_company->create_insurance_company($insurance_company_name, $db); } } else { $insurance_company_id = 0; } $finance_company_name = ($vehicle_data_array["mod-dd-finance-company"]); if($utility->isNotEmpty($finance_company_name)){ $finance_company_id = $finance_company->read_finance_company_id_by_name($finance_company_name, $db); if(!$utility->isNotEmpty($finance_company_id)){ $finance_company_id = $finance_company->create_finance_company($finance_company_name, $db); } } else { $finance_company_id = 0; } // echo $finance_company_id;exit; //DATE FORMATS $insurance_expiration_date = ""; if($utility->isNotEmpty($vehicle_data_array["mod-insurance-exp-date"])){ $insurance_expiration_date = $utility->convert_sql_date($vehicle_data_array["mod-insurance-exp-date"],'mm/dd/yyyy'); } $finance_expiration_date = ""; if($utility->isNotEmpty($vehicle_data_array["mod-finance-exp-date"])){ $finance_expiration_date = $utility->convert_sql_date($vehicle_data_array["mod-finance-exp-date"],'mm/dd/yyyy'); } $delivery_date = ""; if($utility->isNotEmpty($vehicle_data_array["mod-delivery-date"])){ $delivery_date = $utility->convert_sql_date($vehicle_data_array["mod-delivery-date"],'mm/dd/yyyy'); } $sales_date = ""; if($utility->isNotEmpty($vehicle_data_array["mod-sales-date"])){ $sales_date = $utility->convert_sql_date($vehicle_data_array["mod-sales-date"],'mm/dd/yyyy'); } // $insert_vehicle_sales = $sales->create_vehicle_sales( // $sale_id, // '',//$customer_dms_id, // $vehicle_id, // '',//$vehicle_data_array['mod-cs-number'], // '',//$vehicle_data_array['mod-plate-number'], // $vehicle_data_array['mod-order-number'], // '',//$floor_plan_amount, // $sales_date, // $vehicle_data_array['mod-sales-cost'], // $vehicle_data_array['mod-sales-price'], // $vehicle_data_array['mod-sales-discount'], // $insurance_company_id, // $vehicle_data_array['mod-dd-insurance-type'], // $insurance_expiration_date, // $finance_company_id, // $finance_expiration_date, // $vehicle_data_array['mod-dd-source-of-sale'], // '0',//$mode_of_contact_id, // '',//$warehouse, // '',//$stock_number, // '',//$age_of_unit, // '',//$body_size_code, // '',//$claim_number, // '',//$claim_amount, // '',//$deal_number, // '',//$deal_date, // $vehicle_data_array['mod-dd-sales-consultant'], // $vehicle_data_array['mod-driver'], // $delivery_date, // $vehicle_data_array['mod-dd-type-of-payment'], // $vehicle_data_array['mod-dd-group-manager'], // '0',//$company_dealer_id, // '',//$purchase_car_as_id, // '0',//$vehicle_data_array['mod-dd-dms'], // $_SESSION['user']['id'], // '1',//$status // '',//$end_user_name, // $vehicle_data_array['mod-dd-mode-of-sale'], // $db); $insert_vehicle_sales = $sales->update_vehicle_sales( $sale_id, '',//$customer_dms_id, $vehicle_id, '',//$vehicle_data_array['mod-cs-number'], '',//$vehicle_data_array['mod-plate-number'], $vehicle_data_array['mod-order-number'], '',//$floor_plan_amount, $sales_date, $vehicle_data_array['mod-sales-cost'], $vehicle_data_array['mod-sales-price'], $vehicle_data_array['mod-sales-discount'], $insurance_company_id, $vehicle_data_array['mod-dd-insurance-type'], $insurance_expiration_date, $finance_company_id, $finance_expiration_date, $vehicle_data_array['mod-dd-source-of-sale'], '0',//$mode_of_contact_id, '',//$warehouse, '',//$stock_number, '',//$age_of_unit, '',//$body_size_code, '',//$claim_number, '',//$claim_amount, '',//$deal_number, '',//$deal_date, $vehicle_data_array['mod-dd-sales-consultant'], $vehicle_data_array['mod-driver'], $delivery_date, $vehicle_data_array['mod-dd-type-of-payment'], $vehicle_data_array['mod-dd-group-manager'], '0',//$company_dealer_id, '',//$purchase_car_as_id, $_SESSION['user']['id'], '1',//$status $vehicle_data_array['mod-end-user'], $vehicle_data_array['mod-dd-mode-of-sale'], $db); $vehicle_brands_offered = isset($_REQUEST['vehicle_brands_offered']) ? $_REQUEST['vehicle_brands_offered'] : '' ; $sales->delete_sales_offered($sale_id,$db); $vehicle_brands_offered_array = array(); if($vehicle_brands_offered <> ''){ $vehicle_brands_offered = array_map(array($utility, 'upperCaseNestedArray'), $vehicle_brands_offered); $vehicle_brands_offered = array_map(array($db, 'escape'), $vehicle_brands_offered); foreach ($vehicle_brands_offered as $offered){ $description = ($offered['Description']); $brands_offered_id = ($offered['Brand']); $model_offered_id = ($offered['Model']); // $model_offered_name = ($offered['Model']); // $model_offered_id = $model->read_model_id_by_name($model_offered_name, $db); $vehicle_brands_offered_array[] = "('$sale_id','" . $brands_offered_id."', '".$model_offered_id."', '".$description."')"; } $vehicle_brands_offered_to_insert = implode(',', $vehicle_brands_offered_array); $sales->create_sales_brands_offered($vehicle_brands_offered_to_insert, $db); } if($insert_vehicle_sales > 0){ $return_arr["status"] = 1; $return_arr["message"] = "Successfully updated"; }else { $return_arr["status"] = 0; $return_arr["message"] = "Record not updated"; } echo json_encode($return_arr); } else if($apiKey === '3900331554582720' && $utility->isPostMethod($server_method)){ //Create $plate_number = isset($_REQUEST['plate_number']) ? $_REQUEST['plate_number'] : '-1'; $conduction_sticker = isset($_REQUEST['conduction_sticker']) ? $_REQUEST['conduction_sticker'] : '-1'; $brand_name = isset($_REQUEST['brand']) ? $_REQUEST['brand'] : '-1'; $model_name = isset($_REQUEST['model']) ? $_REQUEST['model'] : '-1'; $color_name = isset($_REQUEST['color']) ? $_REQUEST['color'] : '-1'; $order_number = isset($_REQUEST['order_number']) ? $_REQUEST['order_number'] : '-1'; $po_number = isset($_REQUEST['po_number']) ? $_REQUEST['po_number'] : '-1'; $sales_date = isset($_REQUEST['sales_date']) ? $_REQUEST['sales_date'] : '-1'; $sales_cost = isset($_REQUEST['sales_cost']) ? $_REQUEST['sales_cost'] : '-1'; $sales_price = isset($_REQUEST['sales_price']) ? $_REQUEST['sales_price'] : '-1'; $floor_plan_amount = isset($_REQUEST['floor_plan_amount']) ? $_REQUEST['floor_plan_amount'] : '-1'; $claim_amount = isset($_REQUEST['claim_amount']) ? $_REQUEST['claim_amount'] : '-1'; $deal_number = isset($_REQUEST['deal_number']) ? $_REQUEST['deal_number'] : '-1'; $claim_number = isset($_REQUEST['claim_number']) ? $_REQUEST['claim_number'] : '-1'; $deal_date = isset($_REQUEST['deal_date']) ? $_REQUEST['deal_date'] : '-1'; $delivery_date = isset($_REQUEST['delivery_date']) ? $_REQUEST['delivery_date'] : '-1'; $warehouse = isset($_REQUEST['warehouse']) ? $_REQUEST['warehouse'] : '-1'; $stock_number = isset($_REQUEST['stock_number']) ? $_REQUEST['stock_number'] : '-1'; $age_of_unit = isset($_REQUEST['age_of_unit']) ? $_REQUEST['age_of_unit'] : '-1'; $body_size_code = isset($_REQUEST['body_size_code']) ? $_REQUEST['body_size_code'] : '-1'; $insurance_company = isset($_REQUEST['insurance_company']) ? $_REQUEST['insurance_company'] : '-1'; $insurance_type = isset($_REQUEST['insurance_type']) ? $_REQUEST['insurance_type'] : '-1'; $insurance_expiration_date = isset($_REQUEST['insurance_expiration_date']) ? $_REQUEST['insurance_expiration_date'] : '-1'; $financing_company = isset($_REQUEST['financing_company']) ? $_REQUEST['financing_company'] : '-1'; $finance_expiration_date = isset($_REQUEST['finance_expiration_date']) ? $_REQUEST['finance_expiration_date'] : '-1'; $sales_consultant = isset($_REQUEST['sales_consultant']) ? $_REQUEST['sales_consultant'] : '-1'; $group_manager = isset($_REQUEST['group_manager']) ? $_REQUEST['group_manager'] : '-1'; $dms_id = isset($_REQUEST['dms_id']) ? $_REQUEST['dms_id'] : '-1'; $company_id = isset($_REQUEST['company_id']) ? $_REQUEST['company_id'] : '-1'; $dealer_id = isset($_REQUEST['dealer_id']) ? $_REQUEST['dealer_id'] : '-1'; $brand_id = $brand->read_brand_id_by_name($brand_name, $db); if(!$utility->isNotEmpty($brand_id)){ $brand_id = $brand->create_brand($brand_name, $db); } $model_id = $model->read_model_id_by_name($model_name, $db); if(!$utility->isNotEmpty($model_id)){ $model_id = $model->create_model($model_name, $db); } $color_id = $color->read_color_id_by_name($color_name, $db); if(!$utility->isNotEmpty($color_id)){ $color_id = $color->create_color($color_name, $db); } $sales->create_sales($utility->generate_uuid($db), $plate_number, $conduction_sticker, $brand_id, $model_id, $color_id, $order_number, $po_number, $sales_date, $sales_cost, $sales_price, $floor_plan_amount, $claim_amount, $deal_number, $claim_number, $deal_date, $delivery_date, $warehouse, $stock_number, $age_of_unit, $body_size_code, $insurance_company, $insurance_type, $insurance_expiration_date, $financing_company, $finance_expiration_date, $sales_consultant, $group_manager, $dms_id, $company_id, $dealer_id, $db); } else if($apiKey === '1985222949852720' && $utility->isPostMethod($server_method)){ //Read Vehicle Sale Details $vehicle_id = isset($_REQUEST['vehicle_id']) ? $_REQUEST['vehicle_id'] : '-1'; $vehicle_sales_information = $sales->read_vehicle_sales_details($customer_id, $db); $vehicle_sales_information['mod-dd-insurance-company'] = $insurance_company->read_insurance_company_name_by_id($vehicle_sales_information['mod-dd-insurance-company'], $db); $vehicle_sales_information['mod-dd-insurance-type'] = $insurance_type->read_insurance_type_name_by_id($vehicle_sales_information['mod-dd-insurance-type'], $db); $vehicle_sales_information['mod-dd-finance-company'] = $finance_company->read_finance_company_name_by_id($vehicle_sales_information['mod-dd-finance-company'], $db); echo json_encode(array($vehicle_sales_information)); } else if($apiKey === '4045810733767125' && $utility->isPostMethod($server_method)){ //Read Vehicle Sale Details $vehicle_id = isset($_REQUEST['vehicle_id']) ? $_REQUEST['vehicle_id'] : '-1'; $vehicle_sales_information = $sales->read_vehicle_sales($vehicle_id, $db); if(count($vehicle_sales_information) > 0){ $vehicle_sales_information['mod-sales-date'] = $utility->convert_sql_date_to_date_picker($vehicle_sales_information['mod-sales-date']); $vehicle_sales_information['mod-insurance-exp-date'] = $utility->convert_sql_date_to_date_picker($vehicle_sales_information['mod-insurance-exp-date']); $vehicle_sales_information['mod-finance-exp-date'] = $utility->convert_sql_date_to_date_picker($vehicle_sales_information['mod-finance-exp-date']); $vehicle_sales_information['mod-delivery-date'] = $utility->convert_sql_date_to_date_picker($vehicle_sales_information['mod-delivery-date']); echo json_encode(array($vehicle_sales_information)); }else{ echo json_encode(array()); } // $vehicle_sales_information['mod-dd-insurance-company'] = $insurance_company->read_insurance_company_name_by_id($vehicle_sales_information['mod-dd-insurance-company'], $db); // $vehicle_sales_information['mod-dd-insurance-type'] = $insurance_type->read_insurance_type_name_by_id($vehicle_sales_information['mod-dd-insurance-type'], $db); // $vehicle_sales_information['mod-dd-finance-company'] = $finance_company->read_finance_company_name_by_id($vehicle_sales_information['mod-dd-finance-company'], $db); } else if($apiKey === '9718832291017422' && $utility->isPostMethod($server_method)){ //Read Vehicle Sale Details $vehicle_id = isset($_REQUEST['vehicle_id']) ? $_REQUEST['vehicle_id'] : '-1'; $vehicle_sales_information = $sales->read_vehicle_sales_main($vehicle_id, $db); if(count($vehicle_sales_information) > 0){ $vehicle_sales_information['information-sale-date'] = $utility->convert_sql_date_to_date_picker($vehicle_sales_information['information-sale-date']); $vehicle_sales_information['information-sale-insurance-expiration'] = $utility->convert_sql_date_to_date_picker($vehicle_sales_information['information-sale-insurance-expiration']); $vehicle_sales_information['information-sale-finance-expiration'] = $utility->convert_sql_date_to_date_picker($vehicle_sales_information['information-sale-finance-expiration']); $vehicle_sales_information['information-sale-delivery-date'] = $utility->convert_sql_date_to_date_picker($vehicle_sales_information['information-sale-delivery-date']); // $vehicle_sales_information['mod-dd-insurance-company'] = $insurance_company->read_insurance_company_name_by_id($vehicle_sales_information['mod-dd-insurance-company'], $db); // $vehicle_sales_information['mod-dd-insurance-type'] = $insurance_type->read_insurance_type_name_by_id($vehicle_sales_information['mod-dd-insurance-type'], $db); // $vehicle_sales_information['mod-dd-finance-company'] = $finance_company->read_finance_company_name_by_id($vehicle_sales_information['mod-dd-finance-company'], $db); echo json_encode(array($vehicle_sales_information)); }else{ echo '[]'; } } else if($apiKey === '5339702066391571' && $utility->isPostMethod($server_method)){ //Read Brands Offered $vehicle_id = isset($_REQUEST['vehicle_id']) ? $_REQUEST['vehicle_id'] : '-1' ; $sales_id = $sales->get_sales_id_by_vehicle_id($vehicle_id,$db); $sales->read_sales_brands_offered($sales_id, $db); } else if($apiKey === '0566944804071901' && $utility->isPostMethod($server_method)){ //Check Vehicle $conduction_sticker = $_REQUEST['sales_cs_number']; $sales->check_vehicle($conduction_sticker, $db); } else if($apiKey === '7652381353555841' && $utility->isPostMethod($server_method)){ //Read Sales Details $sales_id = isset($_REQUEST['sales_id']) ? $_REQUEST['sales_id'] : '-1' ; $sales->read_sales_details($sales_id, $db); } else if($apiKey === '1468546553238321' && $utility->isPostMethod($server_method)){ //Read Sales Insurance $sales_id = isset($_REQUEST['sales_id']) ? $_REQUEST['sales_id'] : '-1' ; $sales->read_sales_insurance($sales_id, $db); } else if($apiKey === '7367406445221787' && $utility->isPostMethod($server_method)){ //Read Sales DMS $vehicle_id = isset($_REQUEST['vehicle_id']) ? $_REQUEST['vehicle_id'] : '-1' ; $sales_id = $sales->get_sales_id_by_vehicle_id($vehicle_id,$db); $sales->read_sales_dms($sales_id, $db); } else if($apiKey === '2635594972100656'){ //Update } else if($apiKey === '8969188301030014'){ //Delete }else if($apiKey === '1459051109379886' && $utility->isPostMethod($server_method)){ //Read Customer Interest $start_date = isset($_REQUEST['startDate']) ? $db->escape($_REQUEST['startDate']) : '' ; $end_date = isset($_REQUEST['endDate']) ? $db->escape($_REQUEST['endDate']) : '' ; $company = isset($_REQUEST['company']) ? $db->escape($_REQUEST['company']) : '0' ; $return_arr["total"]= $sales->read_sales_total_number($start_date,$end_date,$company,$granted_company_ids,$db); echo json_encode($return_arr); }else if($apiKey === '3892635489643867' ){ //Read Customer Interest $search = isset($_REQUEST['search']) ? $_REQUEST['search'] : '' ; $offset = isset($_REQUEST['offset']) ? $_REQUEST['offset'] : '' ; $limit = isset($_REQUEST['limit']) ? $_REQUEST['limit'] : '' ; $url = 'https://www.autohub.ph/connect/LOAD_SALES_PERSON.php'; $params = array('apiKey' => $apiKey, 'search' => $search, 'offset' => $offset, 'limit' => $limit); $ch = curl_init(); curl_setopt($ch, CURLOPT_URL,$url); curl_setopt($ch, CURLOPT_POST, 1); curl_setopt($ch, CURLOPT_POSTFIELDS,http_build_query($params)); curl_setopt($ch, CURLOPT_RETURNTRANSFER, true); $server_output = curl_exec($ch); curl_close ($ch); echo $server_output; } else { $return_arr["message"]=" You are not allowed to do this action."; echo $return_arr["message"]; return; } }else{ $return_arr["message"]=" You are not allowed to do this action."; echo $return_arr["message"]; return; } ?>PK ''�ZNM sales_about_side.phpnu �[��� PK ''�Z��d�q �q ] modal/add_sales.phpnu �[��� PK ''�ZS�C,n n q� sales_information.phpnu �[��� PK �;�Z�9!F� � $� sales.phpnu �[��� PK �;�Z 4�6� � � error_lognu �[��� PK �;�ZU��tn tn Թ salesv2.phpnu �[��� PK � �(
| ver. 1.4 |
.
| PHP 8.1.32 | Generation time: 0 |
proxy
|
phpinfo
|
Settings